<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include('../includes/dbcon.php');
//include('functionlevel.php');

// Handle AJAX request for loading scores - THIS MUST BE AT THE TOP
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'load_scores') {
    $subject = $_POST['subject'] ?? '';
    $acyear = $_POST['acyear'] ?? '';
    $term = $_POST['term'] ?? '';
    $classid = $_POST['classid'] ?? '';
    
    if (!empty($subject)) {
        // Get subject ID
        $getsid = $DBcon->prepare("SELECT subject_id FROM subjectss WHERE subjectname = :subj");
        $getsid->bindParam(":subj", $subject);
        $getsid->execute();
        $gw = $getsid->fetch(PDO::FETCH_ASSOC);
        $subjid = $gw['subject_id'] ?? 0;
        
        // Prepare response
        $response = ['success' => false, 'message' => '', 'scores' => []];
        
        if ($subjid) {
            // Get existing scores for all students in the class
            $scoresQuery = $DBcon->prepare("
                SELECT m.regno, m.test, m.exam 
                FROM marks m 
                WHERE m.acyear = :acyear 
                AND m.term = :term 
                AND m.klass = :classid 
                AND m.subject_id = :subjid
            ");
            $scoresQuery->bindParam(":acyear", $acyear);
            $scoresQuery->bindParam(":term", $term);
            $scoresQuery->bindParam(":classid", $classid);
            $scoresQuery->bindParam(":subjid", $subjid);
            $scoresQuery->execute();
            
            $scores = [];
            while ($scoreRow = $scoresQuery->fetch(PDO::FETCH_ASSOC)) {
                $scores[$scoreRow['regno']] = [
                    'test' => $scoreRow['test'],
                    'exam' => $scoreRow['exam']
                ];
            }
            
            // Get students list to match order
            $gts = $DBcon->prepare("SELECT * FROM promoted WHERE class_id = :a AND accademic_year = :b");
            $gts->bindParam(":a", $classid);
            $gts->bindParam(":b", $acyear);
            $gts->execute();
            
            $regnoarray = [];
            while($row = $gts->fetch(PDO::FETCH_ASSOC)) {
                $regnoarray[] = $row['regno'];
            }
            
            // Match scores with student order
            $orderedScores = [];
            foreach ($regnoarray as $regno) {
                $orderedScores[] = $scores[$regno] ?? ['test' => '', 'exam' => ''];
            }
            
            $response['success'] = true;
            $response['scores'] = $orderedScores;
        } else {
            $response['message'] = 'Subject not found';
        }
        
        header('Content-Type: application/json');
        echo json_encode($response);
        exit;
    }
}

function autolevel($stclass) {
    $stclass = strtoupper(trim($stclass));
    
    // Use regex to extract the Basic level
    if (preg_match('/JSS\s*([1-6])/i', $stclass, $matches)) {
        return 'JSS ' . $matches[1];
    }
    
    return null;
}

if(isset($_SESSION['usermail'])) {
    $tmail = $_SESSION['usermail'];
    $tsubj = $_SESSION['subj'] ?? '';
}

if(!isset($_SESSION['yr'])) {
    header("location: resultdetails");
    exit;
}

$message = [];
$admin = $_SESSION['username'] ?? '';
$acyear = $_SESSION['yr'] ?? '';
$schterm = $_SESSION['term'] ?? '';
$classid = $_SESSION['classid'] ?? '';
$lv = autolevel($classid);
$msg = '';

// Get students list
$gts = $DBcon->prepare("SELECT * FROM promoted WHERE class_id = :a AND accademic_year = :b");
$gts->bindParam(":a", $classid);
$gts->bindParam(":b", $acyear);
$gts->execute();

$regnoarray = [];
$sname = [];

while($row = $gts->fetch(PDO::FETCH_ASSOC)) {
    $regnoarray[] = $row['regno'];
    
    $getname = $DBcon->prepare("SELECT * FROM students_info WHERE regno = :r");
    $getname->bindParam(":r", $row['regno']);
    $getname->execute();
    $rown = $getname->fetch(PDO::FETCH_ASSOC);
    $fulname = $rown['fullname'] ?? '';
    
    $sname[] = $fulname;
}

$length = count($regnoarray);

if (isset($_POST['submit']) && !isset($_POST['action'])) {
    $subj = trim($_POST['subject'] ?? '');
    
    if (!empty($subj)) {
        $getsid = $DBcon->prepare("SELECT subject_id FROM subjectss WHERE subjectname = :subj");
        $getsid->bindParam(":subj", $subj);
        $getsid->execute();
        $gw = $getsid->fetch(PDO::FETCH_ASSOC);
        $subjid = $gw['subject_id'] ?? 0;

        $successCount = 0;
        
        for($x = 0; $x < $length; $x++) {
            $reg = $regnoarray[$x];
            $test = $_POST['test'][$x] ?? 0;
            $exam = $_POST['exam'][$x] ?? 0;
            
            // Convert to integers and validate
            $test = is_numeric($test) ? (int)$test : 0;
            $exam = is_numeric($exam) ? (int)$exam : 0;
            
            // Set to 0 if empty
            if(empty($test)) $test = 0;
            if(empty($exam)) $exam = 0;
            
            // Check if record exists
            $check = $DBcon->prepare("SELECT * FROM marks WHERE acyear = :acyear AND subject_id = :subjid AND term = :term AND klass = :classid AND regno = :regno");
            $check->bindParam(":acyear", $acyear);
            $check->bindParam(":subjid", $subjid);
            $check->bindParam(":term", $schterm);
            $check->bindParam(":classid", $classid);
            $check->bindParam(":regno", $reg);
            $check->execute();
            
            if($check->rowCount() > 0) {
                // Update existing record
                $sql = $DBcon->prepare("UPDATE marks SET test = :test, exam = :exam, admin = :admin 
                                       WHERE acyear = :acyear AND term = :term AND klass = :classid 
                                       AND subject_id = :subjid AND regno = :regno");
                $sql->bindParam(":test", $test);
                $sql->bindParam(":exam", $exam);
                $sql->bindParam(":admin", $admin);
                $sql->bindParam(":acyear", $acyear);
                $sql->bindParam(":term", $schterm);
                $sql->bindParam(":classid", $classid);
                $sql->bindParam(":subjid", $subjid);
                $sql->bindParam(":regno", $reg);
            } else {
                // Insert new record
                $sql = $DBcon->prepare("INSERT INTO marks (acyear, term, klass, subject, subject_id, regno, level, test, exam, admin) 
                                       VALUES (:a, :b, :c, :d, :e, :f, :g, :h, :i, :j)");
                $sql->bindParam(":a", $acyear);
                $sql->bindParam(":b", $schterm);
                $sql->bindParam(":c", $classid);
                $sql->bindParam(":d", $subj);
                $sql->bindParam(":e", $subjid);
                $sql->bindParam(":f", $reg);
                $sql->bindParam(":g", $lv);
                $sql->bindParam(":h", $test);
                $sql->bindParam(":i", $exam);
                $sql->bindParam(":j", $admin);
            }
            
            if($sql->execute()) {
                $successCount++;
            }
        }
        
        if($successCount > 0) {
            $msg = htmlspecialchars($subj) . '&nbsp;' . 'Updated successfully for ' . $successCount . ' students';
        } else {
            $msg = 'No records were updated';
        }
    } else {
        $msg = 'Please select a subject';
    }
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <!-- Required meta tags -->
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  <title>School Admin - Edit Results</title>
  <!-- plugins:css -->
  <link rel="stylesheet" href="vendors/iconfonts/font-awesome/css/all.min.css">
  <link rel="stylesheet" href="vendors/css/vendor.bundle.base.css">
  <link rel="stylesheet" href="vendors/css/vendor.bundle.addons.css">
  <!-- endinject -->
  <!-- plugin css for this page -->
  <!-- End plugin css for this page -->
  <!-- inject:css -->
  <link rel="stylesheet" href="css/style.css">
  <!-- endinject -->
</head>
<body>
  <div class="container-scroller">
  <?php include("header.php"); ?>
    <div class="container-fluid page-body-wrapper">
      <!-- partial:partials/_settings-panel.html -->
      <?php include("sidebar.php"); ?>
      <div class="main-panel">
      <div class="content-wrapper">
          <div class="page-header">
            <h3 class="page-title">
              Dashboard
            </h3>
          </div>
          
          <div class="row">
            <div class="col-md-12 grid-margin stretch-card">
              <div class="card">
                <div class="card-body">
                  <h4 class="card-title">
                    <i class="fas fa-edit"></i>
               Edit Student Results
                  </h4>
                  <div class="d-flex align-items-center flex-wrap text-nowrap">
           <button type="button" class="btn btn-primary btn-icon-text mb-2 mb-md-0">
             Result Details
            </button> &nbsp;&nbsp;
             <button type="button" class="btn btn-primary btn-icon-text mb-2 mb-md-0">
             <?php if(isset($_SESSION['yr'])) echo htmlspecialchars($_SESSION['yr']); ?>
            </button> &nbsp;&nbsp;
            <button type="button" class="btn btn-primary btn-icon-text mb-2 mb-md-0">
             <?php if(isset($_SESSION['term'])) echo htmlspecialchars($_SESSION['term']); ?>
            </button>&nbsp;&nbsp;
             <button type="button" class="btn btn-primary btn-icon-text mb-2 mb-md-0">
             <?php if(isset($_SESSION['classid'])) echo htmlspecialchars($_SESSION['classid']); ?>
            </button> &nbsp;&nbsp;
             <a href="regsubjects" class="btn btn-primary btn-icon-text mb-2 mb-md-0">ADD SUBJECT</a>
             &nbsp;&nbsp;
           <a href="resultdetails" class="btn btn-primary btn-icon-text mb-2 mb-md-0">CHANGE CLASS</a>
          </div>
                  <br/>
<?php if (!empty($msg)): ?>
<div class="alert alert-success" style="font-size:18px;">                      
    <?php echo $msg; ?>
</div>
<?php endif; ?>

               <form class="cmxform" id="resultForm" method="post" action="" enctype="multipart/form-data">
                    <fieldset>
                        <div class="form-group">
                            <label for="subject">Subject</label>
                            <select class="form-control" style="background-color:#F9F9F9; color:black;" name="subject" id="subjectSelect" required>
                                <option value="">Select Subject</option>
                                <?php 
                                if(isset($tmail) && isset($sbno)) {
                                    $result = $DBcon->prepare("SELECT subject_id, subjectname FROM subjectss WHERE subject_id = :sbno");
                                    $result->bindParam(":sbno", $sbno);
                                    $result->execute();
                                } else {
                                    $result = $DBcon->prepare("SELECT subject_id, subjectname FROM subjectss");
                                    $result->execute();
                                }
                                
                                while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
                                    echo "<option value='" . htmlspecialchars($row['subjectname']) . "'>" . htmlspecialchars($row['subjectname']) . "</option>";
                                }
                                ?>
                            </select>
                        </div>
                        
                        <div id="loadingMessage" style="display:none;" class="text-center">
                            <i class="fas fa-spinner fa-spin"></i> Loading scores...
                        </div>
                        
                        <table width="100%" border="1" class="table" style="background-color:#F9F9F9; color:#1A1919" id="scoreTable">
                            <tbody>
                                <tr>
                                    <td>SN</td>
                                    <td>NAMES</td>
                                    <td>REG NO</td>
                                    <td>TEST SCORE (40%)</td>
                                    <td>EXAM SCORE (60%)</td>
                                </tr>
                                <?php
                                $cx = 0;
                                for ($x = 0; $x < $length; $x++) {
                                    $cx++;
                                ?>
                                <tr>
                                    <td><?php echo $cx; ?></td>
                                    <td><?php echo htmlspecialchars($sname[$x] ?? ''); ?></td>
                                    <td><?php echo htmlspecialchars($regnoarray[$x] ?? ''); ?></td>
                                    <td><input type="text" name="test[]" id="test_<?php echo $x; ?>" class="form-control test-score" style="background-color:#F9F9F9; color:#1A1919" placeholder="Enter Test score" min="0" max="40" /></td>
                                    <td><input type="text" name="exam[]" id="exam_<?php echo $x; ?>" style="background-color:#F9F9F9; color:#1A1919" class="form-control exam-score" placeholder="Enter Exam score" min="0" max="60" /></td>
                                </tr>      
                                <?php
                                }
                                ?>
                            </tbody>
                        </table> 
                        <br/><br/>    
                        <input class="btn btn-primary" type="submit" name="submit" value="UPDATE RESULT" id="submitBtn" disabled>
                    </fieldset>
                </form>
                </div>
              </div>
            </div>
          </div>
          
          <footer class="footer">
            <div class="d-sm-flex justify-content-center justify-content-sm-between">
              <span class="text-muted text-center text-sm-left d-block d-sm-inline-block">Copyright © 2025. All rights reserved.</span>
              <span class="float-none float-sm-right d-block mt-1 mt-sm-0 text-center">Hand-crafted & made with <i class="far fa-heart text-danger"></i></span>
            </div>
          </footer>
        </div>
      </div>
    </div>
  </div>
  
  <!-- plugins:js -->
  <script src="vendors/js/vendor.bundle.base.js"></script>
  <script src="vendors/js/vendor.bundle.addons.js"></script>
  <!-- endinject -->
  <!-- inject:js -->
  <script src="js/off-canvas.js"></script>
  <script src="js/hoverable-collapse.js"></script>
  <script src="js/misc.js"></script>
  <script src="js/settings.js"></script>
  <script src="js/todolist.js"></script>
  <!-- endinject -->
  <!-- Custom js for this page-->
  <script src="js/dashboard.js"></script>
  
  <script>
  function loadScores() {
      const subjectSelect = document.getElementById('subjectSelect');
      const selectedSubject = subjectSelect.value;
      const loadingMessage = document.getElementById('loadingMessage');
      const scoreTable = document.getElementById('scoreTable');
      const submitBtn = document.getElementById('submitBtn');
      
      if (!selectedSubject) {
          // Clear all scores if no subject is selected
          const testInputs = document.querySelectorAll('.test-score');
          const examInputs = document.querySelectorAll('.exam-score');
          
          testInputs.forEach(input => input.value = '');
          examInputs.forEach(input => input.value = '');
          submitBtn.disabled = true;
          return;
      }
      
      // Show loading message
      loadingMessage.style.display = 'block';
      scoreTable.style.opacity = '0.5';
      submitBtn.disabled = true;
      
      // Create form data
      const formData = new FormData();
      formData.append('action', 'load_scores');
      formData.append('subject', selectedSubject);
      formData.append('acyear', '<?php echo $acyear; ?>');
      formData.append('term', '<?php echo $schterm; ?>');
      formData.append('classid', '<?php echo $classid; ?>');
      
      // Send AJAX request
      fetch(window.location.href, {
          method: 'POST',
          body: formData
      })
      .then(response => {
          if (!response.ok) {
              throw new Error('Network response was not ok');
          }
          return response.json();
      })
      .then(data => {
          // Hide loading message
          loadingMessage.style.display = 'none';
          scoreTable.style.opacity = '1';
          
          if (data.success) {
              // Populate the scores
              data.scores.forEach((score, index) => {
                  const testInput = document.getElementById('test_' + index);
                  const examInput = document.getElementById('exam_' + index);
                  
                  if (testInput) testInput.value = score.test || '';
                  if (examInput) examInput.value = score.exam || '';
              });
              
              // Enable submit button
              submitBtn.disabled = false;
          } else {
              alert('Error loading scores: ' + data.message);
              submitBtn.disabled = true;
          }
      })
      .catch(error => {
          console.error('Error:', error);
          loadingMessage.style.display = 'none';
          scoreTable.style.opacity = '1';
          alert('An error occurred while loading scores. Please check your connection and try again.');
          submitBtn.disabled = true;
      });
  }
  
  // Add event listener to subject select
  document.getElementById('subjectSelect').addEventListener('change', loadScores);
  </script>
  <!-- End custom js for this page-->
</body>
</html>